package com.atguigu.edu.mapper;

import com.atguigu.edu.bean.PaperExamSorceStats;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface  PaperExamSorceStatsMapper {

    @Select("select paper_title,sum(less60) less60,sum(from60to70) from60to70 , sum(from70to90) from70to90\n" +
            " , sum(above90) above90\n" +
            "from dws_exam_paper_score_statistics_window partition par#{date}  group by paper_title")
    List<PaperExamSorceStats> selectExamSorce(Integer date) ;
}
